Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 999 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 124.9 KiB |
| Average record size in memory | 128.0 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 3 |
| DateTime | 2 |
| Text | 2 |
FraudIndicator is highly imbalanced (73.5%) | Imbalance |
SuspiciousFlag is highly imbalanced (83.1%) | Imbalance |
TransactionID is uniformly distributed | Uniform |
TransactionID has unique values | Unique |
TransactionAmount has unique values | Unique |
AnomalyScore has unique values | Unique |
Timestamp has unique values | Unique |
Amount has unique values | Unique |
Reproduction
| Analysis started | 2024-01-01 15:30:43.774019 |
|---|---|
| Analysis finished | 2024-01-01 15:31:11.938807 |
| Duration | 28.16 seconds |
| Software version | ydata-profiling vv4.6.3 |
| Download configuration | config.json |
TransactionID
Real number (ℝ)
UNIFORM UNIQUE
| Distinct | 999 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 500.76276 |
| Minimum | 1 |
|---|---|
| Maximum | 1000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 50.9 |
| Q1 | 251.5 |
| median | 501 |
| Q3 | 750.5 |
| 95-th percentile | 950.1 |
| Maximum | 1000 |
| Range | 999 |
| Interquartile range (IQR) | 499 |
Descriptive statistics
| Standard deviation | 288.84449 |
|---|---|
| Coefficient of variation (CV) | 0.57680903 |
| Kurtosis | -1.199499 |
| Mean | 500.76276 |
| Median Absolute Deviation (MAD) | 250 |
| Skewness | -0.0019809945 |
| Sum | 500262 |
| Variance | 83431.137 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 1 | 0.1% |
| 611 | 1 | 0.1% |
| 508 | 1 | 0.1% |
| 460 | 1 | 0.1% |
| 461 | 1 | 0.1% |
| 463 | 1 | 0.1% |
| 769 | 1 | 0.1% |
| 879 | 1 | 0.1% |
| 465 | 1 | 0.1% |
| 688 | 1 | 0.1% |
| Other values (989) | 989 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 1000 | 1 | |
| 999 | 1 | |
| 998 | 1 | |
| 997 | 1 | |
| 996 | 1 | |
| 995 | 1 | |
| 994 | 1 | |
| 993 | 1 | |
| 992 | 1 | |
| 991 | 1 |
FraudIndicator
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.6 KiB |
| 0 | |
|---|---|
| 1 | 45 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 999 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 954 | |
| 1 | 45 | 4.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 954 | |
| 1 | 45 | 4.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 954 | |
| 1 | 45 | 4.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 999 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 954 | |
| 1 | 45 | 4.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 999 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 954 | |
| 1 | 45 | 4.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 999 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 954 | |
| 1 | 45 | 4.5% |
Category
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.6 KiB |
| Other | |
|---|---|
| Food | |
| Travel | |
| Online | |
| Retail |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.3813814 |
| Min length | 4 |
Characters and Unicode
| Total characters | 5376 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Other |
|---|---|
| 2nd row | Food |
| 3rd row | Online |
| 4th row | Travel |
| 5th row | Retail |
Common Values
| Value | Count | Frequency (%) |
| Other | 210 | |
| Food | 204 | |
| Travel | 198 | |
| Online | 196 | |
| Retail | 191 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| other | 210 | |
| food | 204 | |
| travel | 198 | |
| online | 196 | |
| retail | 191 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 795 | |
| l | 585 | |
| r | 408 | |
| o | 408 | |
| O | 406 | |
| t | 401 | |
| n | 392 | 7.3% |
| a | 389 | 7.2% |
| i | 387 | 7.2% |
| h | 210 | 3.9% |
| Other values (5) | 995 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4377 | |
| Uppercase Letter | 999 | 18.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 795 | |
| l | 585 | |
| r | 408 | |
| o | 408 | |
| t | 401 | |
| n | 392 | |
| a | 389 | |
| i | 387 | |
| h | 210 | 4.8% |
| d | 204 | 4.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 406 | |
| F | 204 | |
| T | 198 | |
| R | 191 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5376 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 795 | |
| l | 585 | |
| r | 408 | |
| o | 408 | |
| O | 406 | |
| t | 401 | |
| n | 392 | 7.3% |
| a | 389 | 7.2% |
| i | 387 | 7.2% |
| h | 210 | 3.9% |
| Other values (5) | 995 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5376 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 795 | |
| l | 585 | |
| r | 408 | |
| o | 408 | |
| O | 406 | |
| t | 401 | |
| n | 392 | 7.3% |
| a | 389 | 7.2% |
| i | 387 | 7.2% |
| h | 210 | 3.9% |
| Other values (5) | 995 |
TransactionAmount
Real number (ℝ)
UNIQUE
| Distinct | 999 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55.884419 |
| Minimum | 10.057864 |
|---|---|
| Maximum | 99.784323 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.6 KiB |
Quantile statistics
| Minimum | 10.057864 |
|---|---|
| 5-th percentile | 13.864613 |
| Q1 | 33.881084 |
| median | 55.999203 |
| Q3 | 77.591591 |
| 95-th percentile | 96.516388 |
| Maximum | 99.784323 |
| Range | 89.72646 |
| Interquartile range (IQR) | 43.710507 |
Descriptive statistics
| Standard deviation | 26.088726 |
|---|---|
| Coefficient of variation (CV) | 0.46683363 |
| Kurtosis | -1.1627959 |
| Mean | 55.884419 |
| Median Absolute Deviation (MAD) | 21.935513 |
| Skewness | -0.046907706 |
| Sum | 55828.534 |
| Variance | 680.62164 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 79.41360746 | 1 | 0.1% |
| 35.53622466 | 1 | 0.1% |
| 91.66415279 | 1 | 0.1% |
| 23.30461399 | 1 | 0.1% |
| 57.62801475 | 1 | 0.1% |
| 71.39490629 | 1 | 0.1% |
| 89.52999305 | 1 | 0.1% |
| 44.37912364 | 1 | 0.1% |
| 58.74144775 | 1 | 0.1% |
| 39.32062115 | 1 | 0.1% |
| Other values (989) | 989 |
| Value | Count | Frequency (%) |
| 10.05786365 | 1 | |
| 10.1432748 | 1 | |
| 10.14333882 | 1 | |
| 10.1900649 | 1 | |
| 10.23072664 | 1 | |
| 10.24979371 | 1 | |
| 10.31780692 | 1 | |
| 10.62508533 | 1 | |
| 10.8310472 | 1 | |
| 10.90584595 | 1 |
| Value | Count | Frequency (%) |
| 99.78432334 | 1 | |
| 99.6010349 | 1 | |
| 99.52235673 | 1 | |
| 99.47675323 | 1 | |
| 99.39547483 | 1 | |
| 99.37033289 | 1 | |
| 99.26625704 | 1 | |
| 99.16801169 | 1 | |
| 99.13454678 | 1 | |
| 99.09515145 | 1 |
AnomalyScore
Real number (ℝ)
UNIQUE
| Distinct | 999 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.49268467 |
| Minimum | 0.000233707 |
|---|---|
| Maximum | 0.99904734 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.6 KiB |
Quantile statistics
| Minimum | 0.000233707 |
|---|---|
| 5-th percentile | 0.042458958 |
| Q1 | 0.25224979 |
| median | 0.49149978 |
| Q3 | 0.74259373 |
| 95-th percentile | 0.94839381 |
| Maximum | 0.99904734 |
| Range | 0.99881363 |
| Interquartile range (IQR) | 0.49034394 |
Descriptive statistics
| Standard deviation | 0.28828554 |
|---|---|
| Coefficient of variation (CV) | 0.58513194 |
| Kurtosis | -1.1952247 |
| Mean | 0.49268467 |
| Median Absolute Deviation (MAD) | 0.24342938 |
| Skewness | 0.0061316224 |
| Sum | 492.19199 |
| Variance | 0.083108553 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.686699464 | 1 | 0.1% |
| 0.646370916 | 1 | 0.1% |
| 0.210671702 | 1 | 0.1% |
| 0.414738295 | 1 | 0.1% |
| 0.41545934 | 1 | 0.1% |
| 0.248070399 | 1 | 0.1% |
| 0.43010061 | 1 | 0.1% |
| 0.334052793 | 1 | 0.1% |
| 0.759861663 | 1 | 0.1% |
| 0.892815846 | 1 | 0.1% |
| Other values (989) | 989 |
| Value | Count | Frequency (%) |
| 0.000233707 | 1 | |
| 0.000312921 | 1 | |
| 0.000929961 | 1 | |
| 0.001311236 | 1 | |
| 0.003313462 | 1 | |
| 0.003373251 | 1 | |
| 0.005158218 | 1 | |
| 0.006120114 | 1 | |
| 0.006331516 | 1 | |
| 0.006563153 | 1 |
| Value | Count | Frequency (%) |
| 0.999047341 | 1 | |
| 0.997339633 | 1 | |
| 0.997038134 | 1 | |
| 0.995561768 | 1 | |
| 0.99233785 | 1 | |
| 0.99192332 | 1 | |
| 0.991626339 | 1 | |
| 0.989993343 | 1 | |
| 0.989508393 | 1 | |
| 0.986039738 | 1 |
Timestamp
Date
UNIQUE
| Distinct | 999 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.6 KiB |
| Minimum | 2022-01-01 00:00:00 |
|---|---|
| Maximum | 2022-12-01 23:00:00 |
Histogram with fixed size bins (bins=50)
MerchantID
Real number (ℝ)
| Distinct | 650 |
|---|---|
| Distinct (%) | 65.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2504.975 |
| Minimum | 2001 |
|---|---|
| Maximum | 3000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.6 KiB |
Quantile statistics
| Minimum | 2001 |
|---|---|
| 5-th percentile | 2053.7 |
| Q1 | 2255.5 |
| median | 2501 |
| Q3 | 2761.5 |
| 95-th percentile | 2946 |
| Maximum | 3000 |
| Range | 999 |
| Interquartile range (IQR) | 506 |
Descriptive statistics
| Standard deviation | 288.42912 |
|---|---|
| Coefficient of variation (CV) | 0.11514252 |
| Kurtosis | -1.2130552 |
| Mean | 2504.975 |
| Median Absolute Deviation (MAD) | 253 |
| Skewness | -0.0054961984 |
| Sum | 2502470 |
| Variance | 83191.357 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2597 | 4 | 0.4% |
| 2444 | 4 | 0.4% |
| 2239 | 4 | 0.4% |
| 2850 | 4 | 0.4% |
| 2479 | 4 | 0.4% |
| 2631 | 4 | 0.4% |
| 2736 | 4 | 0.4% |
| 2200 | 4 | 0.4% |
| 2112 | 4 | 0.4% |
| 2081 | 4 | 0.4% |
| Other values (640) | 959 |
| Value | Count | Frequency (%) |
| 2001 | 1 | 0.1% |
| 2004 | 2 | |
| 2005 | 1 | 0.1% |
| 2007 | 4 | |
| 2008 | 1 | 0.1% |
| 2010 | 2 | |
| 2011 | 1 | 0.1% |
| 2012 | 1 | 0.1% |
| 2013 | 2 | |
| 2014 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 3000 | 1 | 0.1% |
| 2998 | 1 | 0.1% |
| 2997 | 2 | |
| 2995 | 1 | 0.1% |
| 2994 | 1 | 0.1% |
| 2993 | 1 | 0.1% |
| 2992 | 2 | |
| 2991 | 1 | 0.1% |
| 2989 | 1 | 0.1% |
| 2984 | 3 |
Amount
Real number (ℝ)
UNIQUE
| Distinct | 999 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55.395063 |
| Minimum | 10.006933 |
|---|---|
| Maximum | 99.88741 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.6 KiB |
Quantile statistics
| Minimum | 10.006933 |
|---|---|
| 5-th percentile | 14.18634 |
| Q1 | 34.48377 |
| median | 57.868203 |
| Q3 | 75.867802 |
| 95-th percentile | 95.224008 |
| Maximum | 99.88741 |
| Range | 89.880477 |
| Interquartile range (IQR) | 41.384032 |
Descriptive statistics
| Standard deviation | 25.083366 |
|---|---|
| Coefficient of variation (CV) | 0.45280869 |
| Kurtosis | -1.0980006 |
| Mean | 55.395063 |
| Median Absolute Deviation (MAD) | 20.444505 |
| Skewness | -0.074880452 |
| Sum | 55339.667 |
| Variance | 629.17524 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 55.53033443 | 1 | 0.1% |
| 88.34186423 | 1 | 0.1% |
| 14.13938756 | 1 | 0.1% |
| 83.69207704 | 1 | 0.1% |
| 27.57822485 | 1 | 0.1% |
| 44.86059946 | 1 | 0.1% |
| 39.16310962 | 1 | 0.1% |
| 84.55259194 | 1 | 0.1% |
| 96.7704106 | 1 | 0.1% |
| 23.62371874 | 1 | 0.1% |
| Other values (989) | 989 |
| Value | Count | Frequency (%) |
| 10.00693256 | 1 | |
| 10.04748839 | 1 | |
| 10.58886273 | 1 | |
| 10.64214063 | 1 | |
| 10.66165127 | 1 | |
| 10.80241294 | 1 | |
| 10.86384497 | 1 | |
| 10.86708774 | 1 | |
| 10.9330459 | 1 | |
| 10.98045532 | 1 |
| Value | Count | Frequency (%) |
| 99.88740974 | 1 | |
| 99.87930231 | 1 | |
| 99.83263446 | 1 | |
| 99.77535839 | 1 | |
| 99.71923371 | 1 | |
| 99.61607032 | 1 | |
| 99.57766068 | 1 | |
| 99.24329386 | 1 | |
| 99.1004274 | 1 | |
| 98.80425008 | 1 |
CustomerID
Real number (ℝ)
| Distinct | 636 |
|---|---|
| Distinct (%) | 63.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1497.0991 |
| Minimum | 1001 |
|---|---|
| Maximum | 2000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.6 KiB |
Quantile statistics
| Minimum | 1001 |
|---|---|
| 5-th percentile | 1052.9 |
| Q1 | 1239 |
| median | 1501 |
| Q3 | 1739.5 |
| 95-th percentile | 1958.2 |
| Maximum | 2000 |
| Range | 999 |
| Interquartile range (IQR) | 500.5 |
Descriptive statistics
| Standard deviation | 288.98653 |
|---|---|
| Coefficient of variation (CV) | 0.193031 |
| Kurtosis | -1.1753761 |
| Mean | 1497.0991 |
| Median Absolute Deviation (MAD) | 250 |
| Skewness | 0.028045889 |
| Sum | 1495602 |
| Variance | 83513.216 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1825 | 6 | 0.6% |
| 1424 | 6 | 0.6% |
| 1666 | 6 | 0.6% |
| 1322 | 5 | 0.5% |
| 1311 | 5 | 0.5% |
| 1618 | 5 | 0.5% |
| 1480 | 4 | 0.4% |
| 1117 | 4 | 0.4% |
| 1503 | 4 | 0.4% |
| 1405 | 4 | 0.4% |
| Other values (626) | 950 |
| Value | Count | Frequency (%) |
| 1001 | 1 | |
| 1003 | 1 | |
| 1004 | 2 | |
| 1005 | 1 | |
| 1007 | 1 | |
| 1008 | 1 | |
| 1009 | 2 | |
| 1012 | 2 | |
| 1014 | 1 | |
| 1016 | 1 |
| Value | Count | Frequency (%) |
| 2000 | 3 | |
| 1999 | 2 | |
| 1998 | 1 | 0.1% |
| 1997 | 1 | 0.1% |
| 1996 | 1 | 0.1% |
| 1995 | 4 | |
| 1994 | 2 | |
| 1993 | 1 | 0.1% |
| 1992 | 1 | 0.1% |
| 1991 | 2 |
Name
Text
| Distinct | 636 |
|---|---|
| Distinct (%) | 63.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.6 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
Characters and Unicode
| Total characters | 12987 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 379 ? |
|---|---|
| Unique (%) | 37.9% |
Sample
| 1st row | Customer 1952 |
|---|---|
| 2nd row | Customer 1952 |
| 3rd row | Customer 1027 |
| 4th row | Customer 1955 |
| 5th row | Customer 1955 |
| Value | Count | Frequency (%) |
| customer | 999 | |
| 1424 | 6 | 0.3% |
| 1666 | 6 | 0.3% |
| 1825 | 6 | 0.3% |
| 1322 | 5 | 0.3% |
| 1311 | 5 | 0.3% |
| 1618 | 5 | 0.3% |
| 1995 | 4 | 0.2% |
| 1796 | 4 | 0.2% |
| 1244 | 4 | 0.2% |
| Other values (627) | 954 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1313 | |
| e | 999 | 7.7% |
| u | 999 | 7.7% |
| 999 | 7.7% | |
| r | 999 | 7.7% |
| C | 999 | 7.7% |
| m | 999 | 7.7% |
| o | 999 | 7.7% |
| t | 999 | 7.7% |
| s | 999 | 7.7% |
| Other values (9) | 2683 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6993 | |
| Decimal Number | 3996 | |
| Space Separator | 999 | 7.7% |
| Uppercase Letter | 999 | 7.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1313 | |
| 5 | 321 | 8.0% |
| 6 | 316 | 7.9% |
| 2 | 315 | 7.9% |
| 9 | 307 | 7.7% |
| 0 | 301 | 7.5% |
| 7 | 291 | 7.3% |
| 4 | 287 | 7.2% |
| 3 | 274 | 6.9% |
| 8 | 271 | 6.8% |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 999 | |
| u | 999 | |
| r | 999 | |
| m | 999 | |
| o | 999 | |
| t | 999 | |
| s | 999 |
Space Separator
| Value | Count | Frequency (%) |
| 999 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 999 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7992 | |
| Common | 4995 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 1313 | |
| 999 | ||
| 5 | 321 | 6.4% |
| 6 | 316 | 6.3% |
| 2 | 315 | 6.3% |
| 9 | 307 | 6.1% |
| 0 | 301 | 6.0% |
| 7 | 291 | 5.8% |
| 4 | 287 | 5.7% |
| 3 | 274 | 5.5% |
Latin
| Value | Count | Frequency (%) |
| e | 999 | |
| u | 999 | |
| r | 999 | |
| C | 999 | |
| m | 999 | |
| o | 999 | |
| t | 999 | |
| s | 999 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12987 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 1313 | |
| e | 999 | 7.7% |
| u | 999 | 7.7% |
| 999 | 7.7% | |
| r | 999 | 7.7% |
| C | 999 | 7.7% |
| m | 999 | 7.7% |
| o | 999 | 7.7% |
| t | 999 | 7.7% |
| s | 999 | 7.7% |
| Other values (9) | 2683 |
Age
Real number (ℝ)
| Distinct | 47 |
|---|---|
| Distinct (%) | 4.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 39.847848 |
| Minimum | 18 |
|---|---|
| Maximum | 64 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.6 KiB |
Quantile statistics
| Minimum | 18 |
|---|---|
| 5-th percentile | 20 |
| Q1 | 29 |
| median | 39 |
| Q3 | 51 |
| 95-th percentile | 61 |
| Maximum | 64 |
| Range | 46 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 13.08148 |
|---|---|
| Coefficient of variation (CV) | 0.32828574 |
| Kurtosis | -1.1244721 |
| Mean | 39.847848 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 0.10463238 |
| Sum | 39808 |
| Variance | 171.12512 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=47)
| Value | Count | Frequency (%) |
| 33 | 37 | 3.7% |
| 47 | 35 | 3.5% |
| 37 | 31 | 3.1% |
| 18 | 29 | 2.9% |
| 35 | 29 | 2.9% |
| 31 | 28 | 2.8% |
| 21 | 27 | 2.7% |
| 27 | 27 | 2.7% |
| 29 | 27 | 2.7% |
| 26 | 25 | 2.5% |
| Other values (37) | 704 |
| Value | Count | Frequency (%) |
| 18 | 29 | |
| 19 | 18 | |
| 20 | 15 | |
| 21 | 27 | |
| 22 | 20 | |
| 23 | 23 | |
| 24 | 14 | |
| 25 | 14 | |
| 26 | 25 | |
| 27 | 27 |
| Value | Count | Frequency (%) |
| 64 | 9 | 0.9% |
| 63 | 18 | |
| 62 | 17 | |
| 61 | 16 | |
| 60 | 22 | |
| 59 | 17 | |
| 58 | 23 | |
| 57 | 18 | |
| 56 | 14 | |
| 55 | 24 |
Address
Text
| Distinct | 636 |
|---|---|
| Distinct (%) | 63.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.6 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Characters and Unicode
| Total characters | 11988 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 379 ? |
|---|---|
| Unique (%) | 37.9% |
Sample
| 1st row | Address 1952 |
|---|---|
| 2nd row | Address 1952 |
| 3rd row | Address 1027 |
| 4th row | Address 1955 |
| 5th row | Address 1955 |
| Value | Count | Frequency (%) |
| address | 999 | |
| 1424 | 6 | 0.3% |
| 1666 | 6 | 0.3% |
| 1825 | 6 | 0.3% |
| 1322 | 5 | 0.3% |
| 1311 | 5 | 0.3% |
| 1618 | 5 | 0.3% |
| 1995 | 4 | 0.2% |
| 1796 | 4 | 0.2% |
| 1244 | 4 | 0.2% |
| Other values (627) | 954 |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 1998 | |
| s | 1998 | |
| 1 | 1313 | |
| A | 999 | |
| r | 999 | |
| e | 999 | |
| 999 | ||
| 5 | 321 | 2.7% |
| 6 | 316 | 2.6% |
| 2 | 315 | 2.6% |
| Other values (6) | 1731 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5994 | |
| Decimal Number | 3996 | |
| Uppercase Letter | 999 | 8.3% |
| Space Separator | 999 | 8.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1313 | |
| 5 | 321 | 8.0% |
| 6 | 316 | 7.9% |
| 2 | 315 | 7.9% |
| 9 | 307 | 7.7% |
| 0 | 301 | 7.5% |
| 7 | 291 | 7.3% |
| 4 | 287 | 7.2% |
| 3 | 274 | 6.9% |
| 8 | 271 | 6.8% |
Lowercase Letter
| Value | Count | Frequency (%) |
| d | 1998 | |
| s | 1998 | |
| r | 999 | |
| e | 999 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 999 |
Space Separator
| Value | Count | Frequency (%) |
| 999 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6993 | |
| Common | 4995 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 1313 | |
| 999 | ||
| 5 | 321 | 6.4% |
| 6 | 316 | 6.3% |
| 2 | 315 | 6.3% |
| 9 | 307 | 6.1% |
| 0 | 301 | 6.0% |
| 7 | 291 | 5.8% |
| 4 | 287 | 5.7% |
| 3 | 274 | 5.5% |
Latin
| Value | Count | Frequency (%) |
| d | 1998 | |
| s | 1998 | |
| A | 999 | |
| r | 999 | |
| e | 999 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11988 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| d | 1998 | |
| s | 1998 | |
| 1 | 1313 | |
| A | 999 | |
| r | 999 | |
| e | 999 | |
| 999 | ||
| 5 | 321 | 2.7% |
| 6 | 316 | 2.6% |
| 2 | 315 | 2.6% |
| Other values (6) | 1731 |
AccountBalance
Real number (ℝ)
| Distinct | 636 |
|---|---|
| Distinct (%) | 63.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5719.38 |
| Minimum | 1056.3012 |
|---|---|
| Maximum | 9999.7762 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.6 KiB |
Quantile statistics
| Minimum | 1056.3012 |
|---|---|
| 5-th percentile | 1669.6768 |
| Q1 | 3494.5829 |
| median | 5760.8876 |
| Q3 | 7926.3382 |
| 95-th percentile | 9449.859 |
| Maximum | 9999.7762 |
| Range | 8943.4751 |
| Interquartile range (IQR) | 4431.7553 |
Descriptive statistics
| Standard deviation | 2538.7559 |
|---|---|
| Coefficient of variation (CV) | 0.44388656 |
| Kurtosis | -1.1915559 |
| Mean | 5719.38 |
| Median Absolute Deviation (MAD) | 2228.2299 |
| Skewness | -0.099727124 |
| Sum | 5713660.6 |
| Variance | 6445281.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4886.010825 | 6 | 0.6% |
| 4344.549864 | 6 | 0.6% |
| 9674.062164 | 6 | 0.6% |
| 9411.508717 | 5 | 0.5% |
| 9253.478917 | 5 | 0.5% |
| 6741.429339 | 5 | 0.5% |
| 7269.756044 | 4 | 0.4% |
| 7288.036638 | 4 | 0.4% |
| 4370.431522 | 4 | 0.4% |
| 9246.516979 | 4 | 0.4% |
| Other values (626) | 950 |
| Value | Count | Frequency (%) |
| 1056.301181 | 1 | 0.1% |
| 1069.843868 | 1 | 0.1% |
| 1087.073831 | 1 | 0.1% |
| 1097.423046 | 2 | |
| 1098.721299 | 1 | 0.1% |
| 1106.441844 | 1 | 0.1% |
| 1111.772167 | 2 | |
| 1117.747401 | 1 | 0.1% |
| 1150.295949 | 3 | |
| 1153.123295 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 9999.776239 | 1 | |
| 9996.991525 | 1 | |
| 9992.495729 | 1 | |
| 9974.701765 | 1 | |
| 9960.172528 | 2 | |
| 9938.922919 | 2 | |
| 9934.498597 | 1 | |
| 9927.157719 | 2 | |
| 9922.291973 | 1 | |
| 9911.337339 | 1 |
LastLogin
Date
| Distinct | 636 |
|---|---|
| Distinct (%) | 63.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.6 KiB |
| Minimum | 2022-01-01 00:00:00 |
|---|---|
| Maximum | 2024-09-26 00:00:00 |
Histogram with fixed size bins (bins=50)
SuspiciousFlag
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.6 KiB |
| 0 | |
|---|---|
| 1 | 25 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 999 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 974 | |
| 1 | 25 | 2.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 974 | |
| 1 | 25 | 2.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 974 | |
| 1 | 25 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 999 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 974 | |
| 1 | 25 | 2.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 999 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 974 | |
| 1 | 25 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 999 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 974 | |
| 1 | 25 | 2.5% |
| AccountBalance | Age | Amount | AnomalyScore | Category | CustomerID | FraudIndicator | MerchantID | SuspiciousFlag | TransactionAmount | TransactionID | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| AccountBalance | 1.000 | 0.016 | 0.005 | -0.011 | 0.075 | -0.059 | 0.000 | 0.023 | 0.131 | 0.043 | -0.057 |
| Age | 0.016 | 1.000 | -0.035 | -0.026 | 0.000 | -0.005 | 0.000 | 0.014 | 0.121 | -0.031 | -0.010 |
| Amount | 0.005 | -0.035 | 1.000 | -0.006 | 0.000 | -0.030 | 0.000 | 0.009 | 0.000 | -0.002 | 0.024 |
| AnomalyScore | -0.011 | -0.026 | -0.006 | 1.000 | 0.038 | 0.009 | 0.056 | 0.072 | 0.071 | -0.040 | 0.078 |
| Category | 0.075 | 0.000 | 0.000 | 0.038 | 1.000 | 0.020 | 0.000 | 0.007 | 0.045 | -0.013 | -0.017 |
| CustomerID | -0.059 | -0.005 | -0.030 | 0.009 | 0.020 | 1.000 | 0.000 | 0.022 | 0.102 | -0.065 | 0.010 |
| FraudIndicator | 0.000 | 0.000 | 0.000 | 0.056 | 0.000 | 0.000 | 1.000 | -0.001 | 0.028 | -0.034 | -0.036 |
| MerchantID | 0.023 | 0.014 | 0.009 | 0.072 | 0.007 | 0.022 | -0.001 | 1.000 | 0.029 | 0.029 | 0.017 |
| SuspiciousFlag | 0.131 | 0.121 | 0.000 | 0.071 | 0.045 | 0.102 | 0.028 | 0.029 | 1.000 | 0.005 | -0.039 |
| TransactionAmount | 0.043 | -0.031 | -0.002 | -0.040 | -0.013 | -0.065 | -0.034 | 0.029 | 0.005 | 1.000 | -0.014 |
| TransactionID | -0.057 | -0.010 | 0.024 | 0.078 | -0.017 | 0.010 | -0.036 | 0.017 | -0.039 | -0.014 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| TransactionID | FraudIndicator | Category | TransactionAmount | AnomalyScore | Timestamp | MerchantID | Amount | CustomerID | Name | Age | Address | AccountBalance | LastLogin | SuspiciousFlag | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 0 | Other | 79.413607 | 0.686699 | 01-01-2022 00:00 | 2701 | 55.530334 | 1952 | Customer 1952 | 50 | Address 1952 | 2869.689912 | 2024-08-09 | 0 |
| 1 | 895 | 0 | Food | 90.422026 | 0.040817 | 07-02-2022 06:00 | 2149 | 53.683898 | 1952 | Customer 1952 | 50 | Address 1952 | 2869.689912 | 2024-08-09 | 0 |
| 2 | 2 | 0 | Online | 12.053087 | 0.081749 | 01-01-2022 01:00 | 2070 | 12.881180 | 1027 | Customer 1027 | 46 | Address 1027 | 9527.947107 | 2022-01-27 | 0 |
| 3 | 3 | 0 | Travel | 33.310357 | 0.023857 | 01-01-2022 02:00 | 2238 | 50.176322 | 1955 | Customer 1955 | 34 | Address 1955 | 9288.355525 | 2024-08-12 | 0 |
| 4 | 544 | 0 | Retail | 20.295348 | 0.476812 | 23-01-2022 15:00 | 2643 | 52.991184 | 1955 | Customer 1955 | 34 | Address 1955 | 9288.355525 | 2024-08-12 | 0 |
| 5 | 4 | 0 | Travel | 46.121117 | 0.876994 | 01-01-2022 03:00 | 2879 | 41.634001 | 1796 | Customer 1796 | 33 | Address 1796 | 5588.049942 | 2024-03-06 | 0 |
| 6 | 109 | 0 | Food | 66.514372 | 0.782428 | 05-01-2022 12:00 | 2508 | 48.737959 | 1796 | Customer 1796 | 33 | Address 1796 | 5588.049942 | 2024-03-06 | 0 |
| 7 | 594 | 0 | Other | 10.143275 | 0.123278 | 25-01-2022 17:00 | 2176 | 22.013210 | 1796 | Customer 1796 | 33 | Address 1796 | 5588.049942 | 2024-03-06 | 0 |
| 8 | 985 | 0 | Online | 99.522357 | 0.858960 | 11-02-2022 00:00 | 2010 | 87.011619 | 1796 | Customer 1796 | 33 | Address 1796 | 5588.049942 | 2024-03-06 | 0 |
| 9 | 5 | 0 | Other | 54.051618 | 0.034059 | 01-01-2022 04:00 | 2966 | 78.122853 | 1946 | Customer 1946 | 18 | Address 1946 | 7324.785332 | 2024-08-03 | 0 |
| TransactionID | FraudIndicator | Category | TransactionAmount | AnomalyScore | Timestamp | MerchantID | Amount | CustomerID | Name | Age | Address | AccountBalance | LastLogin | SuspiciousFlag | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 989 | 977 | 0 | Travel | 15.910489 | 0.613371 | 10-02-2022 16:00 | 2661 | 68.467081 | 1153 | Customer 1153 | 26 | Address 1153 | 7795.585807 | 2022-06-02 | 0 |
| 990 | 978 | 0 | Online | 27.016250 | 0.563279 | 10-02-2022 17:00 | 2983 | 41.613844 | 1055 | Customer 1055 | 24 | Address 1055 | 1611.538315 | 2022-02-24 | 0 |
| 991 | 979 | 0 | Other | 79.723448 | 0.039170 | 10-02-2022 18:00 | 2910 | 52.338108 | 1020 | Customer 1020 | 55 | Address 1020 | 3552.855147 | 2022-01-20 | 0 |
| 992 | 980 | 0 | Travel | 36.021252 | 0.507261 | 10-02-2022 19:00 | 2666 | 59.308867 | 1421 | Customer 1421 | 41 | Address 1421 | 6341.743797 | 2023-02-25 | 0 |
| 993 | 984 | 0 | Online | 34.489507 | 0.169398 | 10-02-2022 23:00 | 2593 | 49.450072 | 1884 | Customer 1884 | 55 | Address 1884 | 6010.648922 | 2024-06-02 | 0 |
| 994 | 986 | 0 | Other | 89.972362 | 0.285603 | 11-02-2022 01:00 | 2036 | 29.328815 | 1706 | Customer 1706 | 45 | Address 1706 | 1678.514968 | 2023-12-07 | 0 |
| 995 | 989 | 0 | Food | 17.848481 | 0.029543 | 11-02-2022 04:00 | 2284 | 20.443811 | 1312 | Customer 1312 | 26 | Address 1312 | 6018.443647 | 2022-11-08 | 0 |
| 996 | 996 | 0 | Food | 89.457059 | 0.266778 | 11-02-2022 11:00 | 2150 | 19.876750 | 1411 | Customer 1411 | 19 | Address 1411 | 1290.323059 | 2023-02-15 | 0 |
| 997 | 997 | 0 | Retail | 47.958030 | 0.512483 | 11-02-2022 12:00 | 2888 | 96.299792 | 1566 | Customer 1566 | 39 | Address 1566 | 7067.831609 | 2023-07-20 | 0 |
| 998 | 998 | 0 | Food | 64.210046 | 0.367740 | 11-02-2022 13:00 | 2037 | 75.164459 | 1654 | Customer 1654 | 51 | Address 1654 | 9088.738359 | 2023-10-16 | 0 |